### Senior Secondary 3 (Grade 12) ICT Lesson Plan
**Topic: Database Management II**
#### General Objectives:
- To understand advanced database concepts.
- To handle complex queries and manage database security.
- To develop skills in database backup, restoration, and performance tuning.
#### Lesson Duration:
- 1 hour and 30 minutes
---
### Lesson Overview:
**1. Introduction (15 minutes)**
- **Recap:** Quick review of Database Management I (basic SQL commands, normalization, and ER-diagrams).
- **Objective:** Outline the aims of today’s class focusing on advanced database management topics.
**2. Lecture and Demonstration (20 minutes)**
- **Advanced SQL Queries:**
- Subqueries
- JOINS (INNER, LEFT, RIGHT, FULL OUTER)
- Aggregate functions (SUM, AVG, COUNT, MIN, MAX)
- **Database Security:**
- User roles and permissions
- Encryption and data masking
- **Backup and Restore:**
- Methods of backing up a database (full, differential, incremental)
- Steps for restoring a database
**3. Hands-on Activities (30 minutes)**
- **Lab Exercise:**
- Execute advanced SQL queries using a sample database.
- Perform user role assignments and explore permission settings.
- Simulate a backup and restore process using SQL Server or MySQL.
**4. Group Activity (15 minutes)**
- **Case Study Discussion:**
- Provide a real-world scenario where students must plan database management strategies for a company. Include aspects such as database security, backup, and restore.
**5. Assessment and Review (10 minutes)**
- **Quiz/Game:**
- A quick quiz or interactive Kahoot game to gauge understanding.
- **Q&A Session:**
- Open floor for any questions and clarification.
**6. Summary and Assignment (10 minutes)**
- **Recap:**
- Summarize the key points covered.
- **Homework:**
- Assign a project where students design a small database, implement advanced queries, and create a backup/restore plan.
---
### Materials Needed:
- Computers with SQL Server or MySQL installed
- Projector for demonstration
- Handouts with sample database and queries
- Presentation slides
### Assessment and Evaluation:
- **Continuous Assessment:**
- Participation during hands-on and group activities.
- Quality of discussion in the case study.
- **Final Project:**
- Evaluate the homework project based on correctness, creativity, and understanding of advanced concepts.
---
### Additional Notes:
- Encourage students to collaborate and help each other during lab exercises.
- Provide additional resources for students interested in exploring further (e.g., online tutorials, documentation).
- Use real-world examples to make the lesson more engaging.
This lesson plan aims not only to cover the advanced theoretical aspects of database management but also to provide practical, hands-on experience, equipping students with the skills necessary for the real world.